/*
 Navicat MySQL Data Transfer

 Source Server         : outtest
 Source Server Version : 50623
 Source Host           : 120.24.91.140
 Source Database       : livedb

 Target Server Version : 50623
 File Encoding         : utf-8

 Date: 07/13/2016 21:32:26 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `const_params`
-- ----------------------------
DROP TABLE IF EXISTS `const_params`;
CREATE TABLE `const_params` (
  `Key` varchar(32) NOT NULL,
  `Param1` text,
  `Param2` text,
  PRIMARY KEY (`Key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `const_params`
-- ----------------------------
BEGIN;
INSERT INTO `const_params` VALUES ('BlockLevelPar', '200', ''), ('EquipTypeSlots', '{\"1\":[0,4,5,30,34,35],\"2\":[],\"3\":[7,8,10,11,13,14,37,38,40,41,43,44],\"4\":[9,16,17,19,20,39,46,47,49,50],\"5\":[18,19,48,49],\"6\":[],\"7\":[],\"8\":[22,52],\"9\":[24,54],\"10\":[12,15,42,45],\"11\":[23,53],\"12\":[25,55]}', ''), ('EvadeLevelPar', '7500', ''), ('FarEvadeLevelPar', '5000', ''), ('GeneralPar', '10000', ''), ('HitLevelPar', '5000', '');
COMMIT;

-- ----------------------------
--  Table structure for `const_player`
-- ----------------------------
DROP TABLE IF EXISTS `const_player`;
CREATE TABLE `const_player` (
  `LevelUp` int(3) NOT NULL COMMENT '等级上限',
  `EnergyToRoleExp` int(2) DEFAULT NULL COMMENT '1点体力（精力）转化角色经验',
  `EnergyToSkillExp` int(3) DEFAULT NULL COMMENT '1点体力（精力）转化技能经验',
  `EnergyRecoverTime` int(2) DEFAULT NULL COMMENT '单次体力恢复时间（分钟）',
  PRIMARY KEY (`LevelUp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `d_bagequipment`
-- ----------------------------
DROP TABLE IF EXISTS `d_bagequipment`;
CREATE TABLE `d_bagequipment` (
  `CharId` int(11) NOT NULL,
  `ItemId` int(11) NOT NULL,
  `Uid` bigint(20) NOT NULL,
  `Number` int(11) NOT NULL,
  `Armor` int(11) NOT NULL DEFAULT '0',
  `Sight` float NOT NULL DEFAULT '0',
  `Hp` int(11) NOT NULL DEFAULT '0',
  `Evade` int(11) NOT NULL DEFAULT '0',
  `Speed` float NOT NULL DEFAULT '0',
  `Endurance` int(11) NOT NULL,
  `MaxEndurance` int(11) NOT NULL,
  `IsEquip` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `d_bagequipment`
-- ----------------------------
BEGIN;
INSERT INTO `d_bagequipment` VALUES ('1', '20101', '99', '1', '1', '1', '1', '1', '1', '1', '1', '0'), ('1', '20111', '4294967296', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967297', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967298', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967299', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967300', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967301', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967306', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967307', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967308', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967309', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967310', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967311', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967316', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967317', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967318', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967319', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967320', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967321', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967326', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967327', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967328', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967329', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967330', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967331', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967336', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967337', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967338', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967339', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967340', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967341', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967346', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967347', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967348', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967349', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967350', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967351', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967356', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967357', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967358', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967359', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967360', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967361', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967366', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967367', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967368', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967369', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967370', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967371', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967376', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967377', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967378', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967379', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967380', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967381', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967386', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967387', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967388', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967389', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967390', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967391', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967396', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967397', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967398', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967399', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967400', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967401', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967406', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967407', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967408', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967409', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967410', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967411', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967416', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967417', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967418', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967419', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967420', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967421', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967426', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967427', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967428', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967429', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967430', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967431', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967436', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967437', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967438', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967439', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967440', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967441', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967446', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967447', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967448', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967449', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967450', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967451', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967456', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967457', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967458', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967459', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967460', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967461', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967466', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967467', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967468', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967469', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967470', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967471', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967476', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967477', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967478', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967479', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967480', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967481', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967486', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967487', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967488', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967489', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967490', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967491', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967496', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967497', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967498', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967499', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967500', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967501', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20111', '4294967506', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20112', '4294967507', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20113', '4294967508', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20114', '4294967509', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20115', '4294967510', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('1', '20116', '4294967511', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934593', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934594', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934595', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934596', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934597', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934598', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934603', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934604', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934605', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934606', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934607', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934608', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934613', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934614', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934615', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934616', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934617', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934618', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934623', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934624', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934625', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934626', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934627', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934628', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934633', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934634', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934635', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934636', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934637', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934638', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934643', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934644', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934645', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934646', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934647', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934648', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934653', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934654', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934655', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934656', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934657', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934658', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934663', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934664', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934665', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934666', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934667', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934668', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934673', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934674', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934675', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934676', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934677', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934678', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934683', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934684', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934685', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934686', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934687', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934688', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934693', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934694', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934695', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934696', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934697', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934698', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934703', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934704', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934705', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934706', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934707', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934708', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934713', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934714', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934715', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934716', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934717', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934718', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934723', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934724', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934725', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934726', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934727', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934728', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934733', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934734', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934735', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934736', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934737', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934738', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934743', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934744', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934745', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934746', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934747', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934748', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934753', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934754', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934755', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934756', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934757', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934758', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934763', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934764', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934765', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934766', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934767', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934768', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934773', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934774', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934775', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934776', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934777', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934778', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934783', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934784', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934785', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934786', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934787', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934788', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20111', '8589934793', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20112', '8589934794', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20113', '8589934795', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20114', '8589934796', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20115', '8589934797', '1', '0', '0', '0', '0', '0', '30', '30', '0'), ('2', '20116', '8589934798', '1', '0', '0', '0', '0', '0', '30', '30', '0');
COMMIT;

-- ----------------------------
--  Table structure for `d_bagitems`
-- ----------------------------
DROP TABLE IF EXISTS `d_bagitems`;
CREATE TABLE `d_bagitems` (
  `CharId` int(11) NOT NULL,
  `ItemId` int(11) NOT NULL,
  `Uid` bigint(11) NOT NULL,
  `Number` int(11) NOT NULL,
  `Param` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`Uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `d_bagitems`
-- ----------------------------
BEGIN;
INSERT INTO `d_bagitems` VALUES ('1', '11101', '90', '1', '{\"hp\":100}'), ('3', '19001', '12884901889', '2', '');
COMMIT;

-- ----------------------------
--  Table structure for `d_bagweapon`
-- ----------------------------
DROP TABLE IF EXISTS `d_bagweapon`;
CREATE TABLE `d_bagweapon` (
  `CharId` int(11) NOT NULL,
  `ItemId` int(11) NOT NULL,
  `Uid` bigint(20) NOT NULL,
  `Number` int(11) NOT NULL,
  `AttackRange` float NOT NULL DEFAULT '0',
  `AttackPer` int(11) NOT NULL DEFAULT '0',
  `PenetratePer` int(11) NOT NULL DEFAULT '0',
  `AttackCountMaxPer` int(11) NOT NULL DEFAULT '0',
  `HitPer` int(11) NOT NULL DEFAULT '0',
  `CriPer` int(11) NOT NULL DEFAULT '0',
  `CriDamagePlus` int(11) NOT NULL DEFAULT '0',
  `CriSeniorPer` int(11) NOT NULL DEFAULT '0',
  `CriSeniorDamagePlus` int(11) NOT NULL DEFAULT '0',
  `AimTime` int(11) NOT NULL DEFAULT '0',
  `ReloadTime` int(11) NOT NULL DEFAULT '0',
  `Endurance` int(11) NOT NULL,
  `MaxEndurance` int(11) NOT NULL,
  `Sell` int(11) NOT NULL DEFAULT '0',
  `ShootNum` int(11) NOT NULL DEFAULT '0',
  `Capacity` int(11) NOT NULL DEFAULT '0',
  `VisionRange` float NOT NULL DEFAULT '0',
  `Attack` int(11) NOT NULL DEFAULT '0',
  `Block` int(11) NOT NULL DEFAULT '0',
  `IsEquip` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `d_bagweapon`
-- ----------------------------
BEGIN;
INSERT INTO `d_bagweapon` VALUES ('1', '30106', '4294967302', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967303', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967304', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967305', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967312', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967313', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967314', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967315', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967322', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967323', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967324', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967325', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967332', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967333', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967334', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967335', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967342', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967343', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967344', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967345', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967352', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967353', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967354', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967355', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967362', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967363', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967364', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967365', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967372', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967373', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967374', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967375', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967382', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967383', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967384', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967385', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967392', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967393', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967394', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967395', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967402', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967403', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967404', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967405', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967412', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967413', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967414', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967415', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967422', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967423', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967424', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967425', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967432', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967433', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967434', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967435', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967442', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967443', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967444', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967445', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967452', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967453', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967454', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967455', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967462', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967463', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967464', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967465', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967472', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967473', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967474', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967475', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967482', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967483', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967484', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967485', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967492', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967493', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967494', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967495', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967502', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967503', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967504', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967505', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30106', '4294967512', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30107', '4294967513', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30108', '4294967514', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('1', '30113', '4294967515', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934599', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934600', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934601', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934602', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934609', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934610', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934611', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934612', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934619', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934620', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934621', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934622', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934629', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934630', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934631', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934632', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934639', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934640', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934641', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934642', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934649', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934650', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934651', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934652', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934659', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934660', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934661', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934662', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934669', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934670', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934671', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934672', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934679', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934680', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934681', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934682', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934689', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934690', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934691', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934692', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934699', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934700', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934701', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934702', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934709', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934710', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934711', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934712', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934719', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934720', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934721', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934722', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934729', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934730', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934731', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934732', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934739', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934740', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934741', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934742', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934749', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934750', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934751', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934752', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934759', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934760', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934761', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934762', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934769', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934770', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934771', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934772', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934779', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934780', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934781', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934782', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934789', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934790', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934791', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934792', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30106', '8589934799', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30107', '8589934800', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30108', '8589934801', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('2', '30113', '8589934802', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '0'), ('3', '30101', '12884901890', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '0', '0', '0', '0', '0', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `d_bodyequipment`
-- ----------------------------
DROP TABLE IF EXISTS `d_bodyequipment`;
CREATE TABLE `d_bodyequipment` (
  `CharId` int(11) NOT NULL,
  `HeadUid` bigint(20) NOT NULL DEFAULT '0',
  `MaskUid` bigint(20) NOT NULL DEFAULT '0',
  `ClothUid` bigint(20) NOT NULL DEFAULT '0',
  `TrousouseUid` bigint(20) NOT NULL DEFAULT '0',
  `ShoesUid` bigint(20) NOT NULL DEFAULT '0',
  `RingUid` bigint(20) NOT NULL DEFAULT '0',
  `NecklaceUid` bigint(20) NOT NULL DEFAULT '0',
  `MainHandUid` bigint(20) NOT NULL DEFAULT '0',
  `SubHandUid` bigint(20) NOT NULL DEFAULT '0',
  `GloveUid` bigint(20) NOT NULL DEFAULT '0',
  `DoubleHandUid` bigint(20) NOT NULL DEFAULT '0',
  `DoubleShieldUid` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`CharId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `d_bodyequipment`
-- ----------------------------
BEGIN;
INSERT INTO `d_bodyequipment` VALUES ('1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('3', '0', '0', '0', '0', '0', '0', '0', '12884901890', '0', '0', '0', '0'), ('4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'), ('9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `d_character`
-- ----------------------------
DROP TABLE IF EXISTS `d_character`;
CREATE TABLE `d_character` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `UserId` int(11) NOT NULL,
  `RoleId` int(11) NOT NULL,
  `Level` int(11) NOT NULL,
  `Exp` int(11) NOT NULL,
  `ItemUidSeed` int(11) NOT NULL DEFAULT '1',
  `CurrentHp` int(11) NOT NULL,
  `MaxHp` int(11) NOT NULL,
  `EvadePer` int(11) NOT NULL,
  `Gold` bigint(20) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `d_character`
-- ----------------------------
BEGIN;
INSERT INTO `d_character` VALUES ('1', '1', '1', '1', '0', '220', '100', '100', '0', '1000'), ('2', '2', '1', '1', '0', '211', '100', '100', '0', '1000'), ('3', '3', '1', '1', '0', '3', '100', '100', '0', '1000'), ('4', '4', '1', '1', '0', '1', '100', '100', '0', '1000'), ('5', '5', '1', '1', '0', '1', '100', '100', '0', '1000'), ('6', '6', '1', '1', '0', '1', '100', '100', '0', '1000'), ('7', '7', '1', '1', '0', '1', '100', '100', '0', '1000'), ('8', '8', '1', '1', '0', '1', '100', '100', '0', '1000'), ('9', '9', '1', '1', '0', '1', '100', '100', '0', '1000');
COMMIT;

-- ----------------------------
--  Table structure for `mq_ball`
-- ----------------------------
DROP TABLE IF EXISTS `mq_ball`;
CREATE TABLE `mq_ball` (
  `Id` int(10) NOT NULL,
  `Name` varchar(20) NOT NULL,
  `SkillId` int(10) NOT NULL,
  `BallType` int(2) NOT NULL,
  `Attack` int(6) NOT NULL,
  `ValidRange` float(3,1) NOT NULL COMMENT '作用距离',
  `Penetrate` int(5) NOT NULL DEFAULT '0' COMMENT '穿透力',
  `AttackCountMax` int(3) NOT NULL DEFAULT '1' COMMENT '最大攻击数',
  `FlySpeed` int(5) NOT NULL DEFAULT '5' COMMENT '飞行速度',
  `Slope` int(3) NOT NULL DEFAULT '0' COMMENT '斜率',
  `Angle` int(3) NOT NULL DEFAULT '0' COMMENT '扇形角度',
  `Radius` float(3,1) NOT NULL DEFAULT '2.0' COMMENT '扇形半径',
  `MuzzleEffects` varchar(10) NOT NULL DEFAULT '' COMMENT '枪口特效',
  `FlyingEffects` varchar(10) NOT NULL DEFAULT '' COMMENT '飞行物特效',
  `Loss` float(5,3) NOT NULL COMMENT '损耗',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_ball`
-- ----------------------------
BEGIN;
INSERT INTO `mq_ball` VALUES ('101', '手枪子弹', '1', '1', '10', '7.5', '0', '0', '0', '0', '0', '0.0', '0', '0', '0.300'), ('201', '散弹枪子弹', '2', '0', '20', '12.0', '0', '5', '8', '0', '60', '13.5', '0', '0', '0.200'), ('301', '狙击枪', '1', '1', '30', '20.0', '0', '0', '0', '0', '0', '0.0', '0', '0', '0.500'), ('401', '机枪', '1', '2', '40', '15.0', '0', '0', '0', '0', '0', '0.0', '0', '0', '0.050');
COMMIT;

-- ----------------------------
--  Table structure for `mq_build`
-- ----------------------------
DROP TABLE IF EXISTS `mq_build`;
CREATE TABLE `mq_build` (
  `Id` int(6) NOT NULL,
  `BuildType` int(3) NOT NULL,
  `Width` int(2) NOT NULL COMMENT '碰撞核X长度',
  `Height` int(2) NOT NULL COMMENT '碰撞核Y长度',
  `Resources` varchar(10) NOT NULL COMMENT '资源名',
  `BuildHp` int(10) NOT NULL COMMENT '建筑生命',
  `Data` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_build`
-- ----------------------------
BEGIN;
INSERT INTO `mq_build` VALUES ('1', '1', '1', '1', 'wall01', '20', ''), ('2', '1', '4', '4', 'house01', '80', ''), ('3', '1', '8', '6', 'house02', '80', '');
COMMIT;

-- ----------------------------
--  Table structure for `mq_equipment`
-- ----------------------------
DROP TABLE IF EXISTS `mq_equipment`;
CREATE TABLE `mq_equipment` (
  `Id` int(11) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Icon` varchar(10) NOT NULL,
  `Describe` varchar(64) NOT NULL,
  `Weight` int(11) NOT NULL,
  `Quality` int(11) NOT NULL,
  `Condition` varchar(64) NOT NULL DEFAULT '',
  `Repeat` int(11) NOT NULL,
  `ItemType` int(11) NOT NULL,
  `EquipType` varchar(32) NOT NULL,
  `Exclude` varchar(32) NOT NULL DEFAULT '',
  `Armor` int(11) NOT NULL,
  `Sight` float(11,0) NOT NULL,
  `Hp` int(11) NOT NULL,
  `Evade` int(11) NOT NULL,
  `Speed` float(5,0) NOT NULL,
  `Endurance` int(11) NOT NULL,
  `Resource` varchar(32) NOT NULL DEFAULT '',
  `EquipEffect` varchar(32) NOT NULL DEFAULT '',
  `JoinPointId` varchar(32) NOT NULL DEFAULT '‘’',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_equipment`
-- ----------------------------
BEGIN;
INSERT INTO `mq_equipment` VALUES ('20101', '第1套通用戒指', 'e10001', '第1套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20102', '第1套通用2戒指', 'e10002', '第1套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20103', '第1套通用项链', 'e10003', '第1套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20104', '第1套通用2项链', 'e10004', '第1套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20111', '男性第1套帽子', 'e10005', '男性第1套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '1001'), ('20112', '男性第1套面具', 'e10006', '男性第1套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20113', '男性第1套衣服', 'e10007', '男性第1套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '1002'), ('20114', '男性第1套裤子', 'e10008', '男性第1套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '1003'), ('20115', '男性第1套手套', 'e10009', '男性第1套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '1004'), ('20116', '男性第1套鞋子', 'e10010', '男性第1套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '1005'), ('20121', '女性第1套帽子', 'e10011', '女性第1套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20122', '女性第1套面具', 'e10012', '女性第1套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20123', '女性第1套衣服', 'e10013', '女性第1套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20124', '女性第1套裤子', 'e10014', '女性第1套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20125', '女性第1套手套', 'e10015', '女性第1套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20126', '女性第1套鞋子', 'e10016', '女性第1套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20201', '第2套通用戒指', 'e10017', '第2套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20202', '第2套通用2戒指', 'e10018', '第2套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20203', '第2套通用项链', 'e10019', '第2套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20204', '第2套通用2项链', 'e10020', '第2套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20211', '男性第2套帽子', 'e10021', '男性第2套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20212', '男性第2套面具', 'e10022', '男性第2套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20213', '男性第2套衣服', 'e10023', '男性第2套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20214', '男性第2套裤子', 'e10024', '男性第2套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20215', '男性第2套手套', 'e10025', '男性第2套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20216', '男性第2套鞋子', 'e10026', '男性第2套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20221', '女性第2套帽子', 'e10027', '女性第2套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20222', '女性第2套面具', 'e10028', '女性第2套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20223', '女性第2套衣服', 'e10029', '女性第2套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20224', '女性第2套裤子', 'e10030', '女性第2套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20225', '女性第2套手套', 'e10031', '女性第2套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20226', '女性第2套鞋子', 'e10032', '女性第2套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20301', '第3套通用戒指', 'e10033', '第3套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20302', '第3套通用2戒指', 'e10034', '第3套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20303', '第3套通用项链', 'e10035', '第3套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20304', '第3套通用2项链', 'e10036', '第3套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20311', '男性第3套帽子', 'e10037', '男性第3套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20312', '男性第3套面具', 'e10038', '男性第3套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20313', '男性第3套衣服', 'e10039', '男性第3套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20314', '男性第3套裤子', 'e10040', '男性第3套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20315', '男性第3套手套', 'e10041', '男性第3套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20316', '男性第3套鞋子', 'e10042', '男性第3套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20321', '女性第3套帽子', 'e10043', '女性第3套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20322', '女性第3套面具', 'e10044', '女性第3套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20323', '女性第3套衣服', 'e10045', '女性第3套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20324', '女性第3套裤子', 'e10046', '女性第3套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20325', '女性第3套手套', 'e10047', '女性第3套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20326', '女性第3套鞋子', 'e10048', '女性第3套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20401', '第4套通用戒指', 'e10049', '第4套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20402', '第4套通用2戒指', 'e10050', '第4套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20403', '第4套通用项链', 'e10051', '第4套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20404', '第4套通用2项链', 'e10052', '第4套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20411', '男性第4套帽子', 'e10053', '男性第4套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20412', '男性第4套面具', 'e10054', '男性第4套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20413', '男性第4套衣服', 'e10055', '男性第4套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20414', '男性第4套裤子', 'e10056', '男性第4套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20415', '男性第4套手套', 'e10057', '男性第4套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20416', '男性第4套鞋子', 'e10058', '男性第4套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20421', '女性第4套帽子', 'e10059', '女性第4套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20422', '女性第4套面具', 'e10060', '女性第4套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20423', '女性第4套衣服', 'e10061', '女性第4套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20424', '女性第4套裤子', 'e10062', '女性第4套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20425', '女性第4套手套', 'e10063', '女性第4套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20426', '女性第4套鞋子', 'e10064', '女性第4套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20501', '第5套通用戒指', 'e10065', '第5套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20502', '第5套通用2戒指', 'e10066', '第5套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20503', '第5套通用项链', 'e10067', '第5套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20504', '第5套通用2项链', 'e10068', '第5套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20511', '男性第5套帽子', 'e10069', '男性第5套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20512', '男性第5套面具', 'e10070', '男性第5套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20513', '男性第5套衣服', 'e10071', '男性第5套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20514', '男性第5套裤子', 'e10072', '男性第5套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20515', '男性第5套手套', 'e10073', '男性第5套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20516', '男性第5套鞋子', 'e10074', '男性第5套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20521', '女性第5套帽子', 'e10075', '女性第5套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20522', '女性第5套面具', 'e10076', '女性第5套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20523', '女性第5套衣服', 'e10077', '女性第5套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20524', '女性第5套裤子', 'e10078', '女性第5套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20525', '女性第5套手套', 'e10079', '女性第5套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20526', '女性第5套鞋子', 'e10080', '女性第5套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20601', '第6套通用戒指', 'e10081', '第6套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20602', '第6套通用2戒指', 'e10082', '第6套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20603', '第6套通用项链', 'e10083', '第6套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20604', '第6套通用2项链', 'e10084', '第6套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20611', '男性第6套帽子', 'e10085', '男性第6套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20612', '男性第6套面具', 'e10086', '男性第6套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20613', '男性第6套衣服', 'e10087', '男性第6套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20614', '男性第6套裤子', 'e10088', '男性第6套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20615', '男性第6套手套', 'e10089', '男性第6套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20616', '男性第6套鞋子', 'e10090', '男性第6套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20621', '女性第6套帽子', 'e10091', '女性第6套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20622', '女性第6套面具', 'e10092', '女性第6套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20623', '女性第6套衣服', 'e10093', '女性第6套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20624', '女性第6套裤子', 'e10094', '女性第6套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20625', '女性第6套手套', 'e10095', '女性第6套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20626', '女性第6套鞋子', 'e10096', '女性第6套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20701', '第7套通用戒指', 'e10097', '第7套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20702', '第7套通用2戒指', 'e10098', '第7套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20703', '第7套通用项链', 'e10099', '第7套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20704', '第7套通用2项链', 'e10100', '第7套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20711', '男性第7套帽子', 'e10101', '男性第7套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20712', '男性第7套面具', 'e10102', '男性第7套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20713', '男性第7套衣服', 'e10103', '男性第7套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20714', '男性第7套裤子', 'e10104', '男性第7套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20715', '男性第7套手套', 'e10105', '男性第7套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20716', '男性第7套鞋子', 'e10106', '男性第7套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20721', '女性第7套帽子', 'e10107', '女性第7套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20722', '女性第7套面具', 'e10108', '女性第7套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20723', '女性第7套衣服', 'e10109', '女性第7套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20724', '女性第7套裤子', 'e10110', '女性第7套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20725', '女性第7套手套', 'e10111', '女性第7套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20726', '女性第7套鞋子', 'e10112', '女性第7套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20801', '第8套通用戒指', 'e10113', '第8套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20802', '第8套通用2戒指', 'e10114', '第8套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20803', '第8套通用项链', 'e10115', '第8套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20804', '第8套通用2项链', 'e10116', '第8套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20811', '男性第8套帽子', 'e10117', '男性第8套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20812', '男性第8套面具', 'e10118', '男性第8套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20813', '男性第8套衣服', 'e10119', '男性第8套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20814', '男性第8套裤子', 'e10120', '男性第8套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20815', '男性第8套手套', 'e10121', '男性第8套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20816', '男性第8套鞋子', 'e10122', '男性第8套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20821', '女性第8套帽子', 'e10123', '女性第8套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20822', '女性第8套面具', 'e10124', '女性第8套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20823', '女性第8套衣服', 'e10125', '女性第8套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20824', '女性第8套裤子', 'e10126', '女性第8套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20825', '女性第8套手套', 'e10127', '女性第8套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20826', '女性第8套鞋子', 'e10128', '女性第8套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20901', '第9套通用戒指', 'e10129', '第9套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20902', '第9套通用2戒指', 'e10130', '第9套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20903', '第9套通用项链', 'e10131', '第9套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20904', '第9套通用2项链', 'e10132', '第9套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20911', '男性第9套帽子', 'e10133', '男性第9套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20912', '男性第9套面具', 'e10134', '男性第9套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20913', '男性第9套衣服', 'e10135', '男性第9套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20914', '男性第9套裤子', 'e10136', '男性第9套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20915', '男性第9套手套', 'e10137', '男性第9套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20916', '男性第9套鞋子', 'e10138', '男性第9套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20921', '女性第9套帽子', 'e10139', '女性第9套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20922', '女性第9套面具', 'e10140', '女性第9套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20923', '女性第9套衣服', 'e10141', '女性第9套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20924', '女性第9套裤子', 'e10142', '女性第9套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20925', '女性第9套手套', 'e10143', '女性第9套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('20926', '女性第9套鞋子', 'e10144', '女性第9套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21001', '第10套通用戒指', 'e10145', '第10套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21002', '第10套通用2戒指', 'e10146', '第10套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21003', '第10套通用项链', 'e10147', '第10套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21004', '第10套通用2项链', 'e10148', '第10套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21011', '男性第10套帽子', 'e10149', '男性第10套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21012', '男性第10套面具', 'e10150', '男性第10套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21013', '男性第10套衣服', 'e10151', '男性第10套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21014', '男性第10套裤子', 'e10152', '男性第10套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21015', '男性第10套手套', 'e10153', '男性第10套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21016', '男性第10套鞋子', 'e10154', '男性第10套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21021', '女性第10套帽子', 'e10155', '女性第10套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21022', '女性第10套面具', 'e10156', '女性第10套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21023', '女性第10套衣服', 'e10157', '女性第10套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21024', '女性第10套裤子', 'e10158', '女性第10套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21025', '女性第10套手套', 'e10159', '女性第10套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21026', '女性第10套鞋子', 'e10160', '女性第10套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21101', '第11套通用戒指', 'e10161', '第11套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21102', '第11套通用2戒指', 'e10162', '第11套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21103', '第11套通用项链', 'e10163', '第11套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21104', '第11套通用2项链', 'e10164', '第11套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21111', '男性第11套帽子', 'e10165', '男性第11套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21112', '男性第11套面具', 'e10166', '男性第11套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21113', '男性第11套衣服', 'e10167', '男性第11套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21114', '男性第11套裤子', 'e10168', '男性第11套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21115', '男性第11套手套', 'e10169', '男性第11套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21116', '男性第11套鞋子', 'e10170', '男性第11套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21121', '女性第11套帽子', 'e10171', '女性第11套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21122', '女性第11套面具', 'e10172', '女性第11套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21123', '女性第11套衣服', 'e10173', '女性第11套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21124', '女性第11套裤子', 'e10174', '女性第11套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21125', '女性第11套手套', 'e10175', '女性第11套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21126', '女性第11套鞋子', 'e10176', '女性第11套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21201', '第12套通用戒指', 'e10177', '第12套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21202', '第12套通用2戒指', 'e10178', '第12套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21203', '第12套通用项链', 'e10179', '第12套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21204', '第12套通用2项链', 'e10180', '第12套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21211', '男性第12套帽子', 'e10181', '男性第12套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21212', '男性第12套面具', 'e10182', '男性第12套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21213', '男性第12套衣服', 'e10183', '男性第12套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21214', '男性第12套裤子', 'e10184', '男性第12套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21215', '男性第12套手套', 'e10185', '男性第12套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21216', '男性第12套鞋子', 'e10186', '男性第12套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21221', '女性第12套帽子', 'e10187', '女性第12套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21222', '女性第12套面具', 'e10188', '女性第12套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21223', '女性第12套衣服', 'e10189', '女性第12套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21224', '女性第12套裤子', 'e10190', '女性第12套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21225', '女性第12套手套', 'e10191', '女性第12套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21226', '女性第12套鞋子', 'e10192', '女性第12套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21301', '第13套通用戒指', 'e10193', '第13套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21302', '第13套通用2戒指', 'e10194', '第13套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21303', '第13套通用项链', 'e10195', '第13套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21304', '第13套通用2项链', 'e10196', '第13套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21311', '男性第13套帽子', 'e10197', '男性第13套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21312', '男性第13套面具', 'e10198', '男性第13套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21313', '男性第13套衣服', 'e10199', '男性第13套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21314', '男性第13套裤子', 'e10200', '男性第13套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21315', '男性第13套手套', 'e10201', '男性第13套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21316', '男性第13套鞋子', 'e10202', '男性第13套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21321', '女性第13套帽子', 'e10203', '女性第13套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21322', '女性第13套面具', 'e10204', '女性第13套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21323', '女性第13套衣服', 'e10205', '女性第13套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21324', '女性第13套裤子', 'e10206', '女性第13套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21325', '女性第13套手套', 'e10207', '女性第13套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21326', '女性第13套鞋子', 'e10208', '女性第13套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21401', '第14套通用戒指', 'e10209', '第14套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21402', '第14套通用2戒指', 'e10210', '第14套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21403', '第14套通用项链', 'e10211', '第14套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21404', '第14套通用2项链', 'e10212', '第14套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21411', '男性第14套帽子', 'e10213', '男性第14套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21412', '男性第14套面具', 'e10214', '男性第14套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21413', '男性第14套衣服', 'e10215', '男性第14套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21414', '男性第14套裤子', 'e10216', '男性第14套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21415', '男性第14套手套', 'e10217', '男性第14套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21416', '男性第14套鞋子', 'e10218', '男性第14套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21421', '女性第14套帽子', 'e10219', '女性第14套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21422', '女性第14套面具', 'e10220', '女性第14套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21423', '女性第14套衣服', 'e10221', '女性第14套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21424', '女性第14套裤子', 'e10222', '女性第14套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21425', '女性第14套手套', 'e10223', '女性第14套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21426', '女性第14套鞋子', 'e10224', '女性第14套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21501', '第15套通用戒指', 'e10225', '第15套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21502', '第15套通用2戒指', 'e10226', '第15套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21503', '第15套通用项链', 'e10227', '第15套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21504', '第15套通用2项链', 'e10228', '第15套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21511', '男性第15套帽子', 'e10229', '男性第15套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21512', '男性第15套面具', 'e10230', '男性第15套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21513', '男性第15套衣服', 'e10231', '男性第15套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21514', '男性第15套裤子', 'e10232', '男性第15套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21515', '男性第15套手套', 'e10233', '男性第15套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21516', '男性第15套鞋子', 'e10234', '男性第15套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21521', '女性第15套帽子', 'e10235', '女性第15套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21522', '女性第15套面具', 'e10236', '女性第15套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21523', '女性第15套衣服', 'e10237', '女性第15套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21524', '女性第15套裤子', 'e10238', '女性第15套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21525', '女性第15套手套', 'e10239', '女性第15套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21526', '女性第15套鞋子', 'e10240', '女性第15套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21601', '第16套通用戒指', 'e10241', '第16套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21602', '第16套通用2戒指', 'e10242', '第16套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21603', '第16套通用项链', 'e10243', '第16套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21604', '第16套通用2项链', 'e10244', '第16套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21611', '男性第16套帽子', 'e10245', '男性第16套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21612', '男性第16套面具', 'e10246', '男性第16套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21613', '男性第16套衣服', 'e10247', '男性第16套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21614', '男性第16套裤子', 'e10248', '男性第16套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21615', '男性第16套手套', 'e10249', '男性第16套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21616', '男性第16套鞋子', 'e10250', '男性第16套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21621', '女性第16套帽子', 'e10251', '女性第16套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21622', '女性第16套面具', 'e10252', '女性第16套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21623', '女性第16套衣服', 'e10253', '女性第16套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21624', '女性第16套裤子', 'e10254', '女性第16套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21625', '女性第16套手套', 'e10255', '女性第16套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21626', '女性第16套鞋子', 'e10256', '女性第16套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21701', '第17套通用戒指', 'e10257', '第17套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21702', '第17套通用2戒指', 'e10258', '第17套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21703', '第17套通用项链', 'e10259', '第17套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21704', '第17套通用2项链', 'e10260', '第17套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21711', '男性第17套帽子', 'e10261', '男性第17套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21712', '男性第17套面具', 'e10262', '男性第17套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21713', '男性第17套衣服', 'e10263', '男性第17套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21714', '男性第17套裤子', 'e10264', '男性第17套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21715', '男性第17套手套', 'e10265', '男性第17套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21716', '男性第17套鞋子', 'e10266', '男性第17套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21721', '女性第17套帽子', 'e10267', '女性第17套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21722', '女性第17套面具', 'e10268', '女性第17套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21723', '女性第17套衣服', 'e10269', '女性第17套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21724', '女性第17套裤子', 'e10270', '女性第17套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21725', '女性第17套手套', 'e10271', '女性第17套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21726', '女性第17套鞋子', 'e10272', '女性第17套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21801', '第18套通用戒指', 'e10273', '第18套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21802', '第18套通用2戒指', 'e10274', '第18套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21803', '第18套通用项链', 'e10275', '第18套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21804', '第18套通用2项链', 'e10276', '第18套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21811', '男性第18套帽子', 'e10277', '男性第18套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21812', '男性第18套面具', 'e10278', '男性第18套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21813', '男性第18套衣服', 'e10279', '男性第18套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21814', '男性第18套裤子', 'e10280', '男性第18套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21815', '男性第18套手套', 'e10281', '男性第18套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21816', '男性第18套鞋子', 'e10282', '男性第18套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21821', '女性第18套帽子', 'e10283', '女性第18套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21822', '女性第18套面具', 'e10284', '女性第18套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21823', '女性第18套衣服', 'e10285', '女性第18套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21824', '女性第18套裤子', 'e10286', '女性第18套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21825', '女性第18套手套', 'e10287', '女性第18套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21826', '女性第18套鞋子', 'e10288', '女性第18套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21901', '第19套通用戒指', 'e10289', '第19套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21902', '第19套通用2戒指', 'e10290', '第19套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21903', '第19套通用项链', 'e10291', '第19套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21904', '第19套通用2项链', 'e10292', '第19套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21911', '男性第19套帽子', 'e10293', '男性第19套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21912', '男性第19套面具', 'e10294', '男性第19套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21913', '男性第19套衣服', 'e10295', '男性第19套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21914', '男性第19套裤子', 'e10296', '男性第19套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21915', '男性第19套手套', 'e10297', '男性第19套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21916', '男性第19套鞋子', 'e10298', '男性第19套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21921', '女性第19套帽子', 'e10299', '女性第19套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21922', '女性第19套面具', 'e10300', '女性第19套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21923', '女性第19套衣服', 'e10301', '女性第19套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21924', '女性第19套裤子', 'e10302', '女性第19套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21925', '女性第19套手套', 'e10303', '女性第19套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('21926', '女性第19套鞋子', 'e10304', '女性第19套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22001', '第20套通用戒指', 'e10305', '第20套通用戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22002', '第20套通用2戒指', 'e10306', '第20套通用2戒指', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '6', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22003', '第20套通用项链', 'e10307', '第20套通用项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22004', '第20套通用2项链', 'e10308', '第20套通用2项链', '10', '1', '{\"cond\":{\"sex\":\"all\"},\"consume\":{}}', '1', '20000', '7', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22011', '男性第20套帽子', 'e10309', '男性第20套帽子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22012', '男性第20套面具', 'e10310', '男性第20套面具', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22013', '男性第20套衣服', 'e10311', '男性第20套衣服', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22014', '男性第20套裤子', 'e10312', '男性第20套裤子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22015', '男性第20套手套', 'e10313', '男性第20套手套', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22016', '男性第20套鞋子', 'e10314', '男性第20套鞋子', '10', '1', '{\"cond\":{\"sex\":\"male\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22021', '女性第20套帽子', 'e10315', '女性第20套帽子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '1', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22022', '女性第20套面具', 'e10316', '女性第20套面具', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '2', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22023', '女性第20套衣服', 'e10317', '女性第20套衣服', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '3', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22024', '女性第20套裤子', 'e10318', '女性第20套裤子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '4', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22025', '女性第20套手套', 'e10319', '女性第20套手套', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '10', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0'), ('22026', '女性第20套鞋子', 'e10320', '女性第20套鞋子', '10', '1', '{\"cond\":{\"sex\":\"female\"},\"consume\":{}}', '1', '20000', '5', '0', '1', '0', '0', '0', '0', '30', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `mq_items`
-- ----------------------------
DROP TABLE IF EXISTS `mq_items`;
CREATE TABLE `mq_items` (
  `Id` int(11) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Icon` varchar(32) NOT NULL DEFAULT '',
  `Describe` varchar(64) NOT NULL DEFAULT '',
  `Weight` int(11) NOT NULL,
  `Quality` int(11) NOT NULL,
  `Condition` varchar(64) NOT NULL DEFAULT '',
  `Repeat` int(11) NOT NULL DEFAULT '1',
  `ItemType` int(11) NOT NULL,
  `Param` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_items`
-- ----------------------------
BEGIN;
INSERT INTO `mq_items` VALUES ('11101', '手雷', '1001', '手雷', '10', '1', '', '1', '10000', ''), ('11201', '地雷', '1001', '地雷', '10', '1', '', '1', '10000', ''), ('11301', '绷带', '1001', '绷带', '10', '1', '', '1', '10000', ''), ('11302', '绷带', '1002', '绷带', '10', '1', '', '1', '10000', ''), ('19001', '木材包', '1001', '木材包', '10', '1', '', '10', '30000', ''), ('19002', '石材包', '1001', '石材包', '10', '1', '', '10', '30000', '');
COMMIT;

-- ----------------------------
--  Table structure for `mq_levelexp`
-- ----------------------------
DROP TABLE IF EXISTS `mq_levelexp`;
CREATE TABLE `mq_levelexp` (
  `Level` int(3) NOT NULL,
  `UpgradeRoleExp` int(10) NOT NULL COMMENT '角色升级经验',
  `SkillUpgradeRoleExp` int(6) NOT NULL COMMENT '技能升级角色增加经验',
  `UpgradeSkillExp` int(10) NOT NULL COMMENT '技能升级需要的经验',
  `SkillUpgradeCount` int(3) NOT NULL COMMENT '技能升级次数',
  `SingleSkillExp` int(8) NOT NULL COMMENT '技能单次升级经验',
  `UpSkillExp` int(11) NOT NULL COMMENT '技能经验上限',
  `LevelHp` int(11) NOT NULL COMMENT '每级经验',
  `LevelAddHp` int(11) NOT NULL COMMENT '每级经验增量',
  PRIMARY KEY (`Level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_levelexp`
-- ----------------------------
BEGIN;
INSERT INTO `mq_levelexp` VALUES ('1', '15', '1', '9', '3', '3', '999999999', '30', '1'), ('2', '45', '1', '27', '3', '9', '999999999', '31', '1'), ('3', '92', '1', '76', '4', '19', '999999999', '32', '1'), ('4', '154', '1', '120', '4', '30', '999999999', '33', '2'), ('5', '234', '2', '220', '5', '44', '999999999', '35', '2'), ('6', '332', '2', '310', '5', '62', '999999999', '37', '2'), ('7', '447', '2', '405', '5', '81', '999999999', '39', '2'), ('8', '581', '3', '618', '6', '103', '999999999', '41', '3'), ('9', '734', '4', '762', '6', '127', '999999999', '44', '3'), ('10', '907', '4', '918', '6', '153', '999999999', '47', '3'), ('11', '1099', '5', '1260', '7', '180', '999999999', '50', '3'), ('12', '1312', '6', '1470', '7', '210', '999999999', '53', '4'), ('13', '1547', '7', '1687', '7', '241', '999999999', '57', '4'), ('14', '1803', '8', '2192', '8', '274', '999999999', '61', '4'), ('15', '2080', '9', '2488', '8', '311', '999999999', '65', '4'), ('16', '2381', '10', '2800', '8', '350', '999999999', '69', '5'), ('17', '2705', '11', '3136', '8', '392', '999999999', '74', '5'), ('18', '3052', '12', '3915', '9', '435', '999999999', '79', '5'), ('19', '3423', '14', '4320', '9', '480', '999999999', '84', '5'), ('20', '3820', '15', '4743', '9', '527', '999999999', '89', '6'), ('21', '4241', '16', '5184', '9', '576', '999999999', '95', '6'), ('22', '4688', '17', '6270', '10', '627', '999999999', '101', '6'), ('23', '5161', '19', '6830', '10', '683', '999999999', '107', '6'), ('24', '5661', '21', '7410', '10', '741', '999999999', '113', '7'), ('25', '6188', '23', '8010', '10', '801', '999999999', '120', '7'), ('26', '6742', '24', '8630', '10', '863', '999999999', '127', '7'), ('27', '7325', '26', '10197', '11', '927', '999999999', '134', '7'), ('28', '7937', '28', '10934', '11', '994', '999999999', '141', '8'), ('29', '8578', '31', '11693', '11', '1063', '999999999', '149', '16'), ('30', '9248', '33', '12463', '11', '1133', '999999999', '165', '16'), ('31', '9949', '35', '13266', '11', '1206', '999999999', '181', '16'), ('32', '10681', '36', '15372', '12', '1281', '999999999', '197', '18'), ('33', '11444', '38', '16296', '12', '1358', '999999999', '215', '18'), ('34', '12239', '41', '17244', '12', '1437', '999999999', '233', '18'), ('35', '13066', '44', '18216', '12', '1518', '999999999', '251', '18'), ('36', '13926', '47', '19212', '12', '1601', '999999999', '269', '20'), ('37', '14819', '51', '21918', '13', '1686', '999999999', '289', '20'), ('38', '15746', '53', '23049', '13', '1773', '999999999', '309', '20'), ('39', '16707', '54', '24193', '13', '1861', '999999999', '329', '20'), ('40', '17703', '57', '25376', '13', '1952', '999999999', '349', '22'), ('41', '18735', '60', '26585', '13', '2045', '999999999', '371', '22'), ('42', '19802', '64', '29960', '14', '2140', '999999999', '393', '22'), ('43', '20906', '68', '31318', '14', '2237', '999999999', '415', '22'), ('44', '22047', '72', '32704', '14', '2336', '999999999', '437', '24'), ('45', '23225', '76', '34118', '14', '2437', '999999999', '461', '24'), ('46', '24441', '79', '35560', '14', '2540', '999999999', '485', '24'), ('47', '25695', '81', '39675', '15', '2645', '999999999', '509', '24'), ('48', '26989', '83', '41370', '15', '2758', '999999999', '533', '26'), ('49', '28322', '88', '43095', '15', '2873', '999999999', '559', '26'), ('50', '29694', '92', '44850', '15', '2990', '999999999', '585', '26'), ('51', '31108', '97', '46650', '15', '3110', '999999999', '611', '26'), ('52', '32562', '102', '48480', '15', '3232', '999999999', '637', '28'), ('53', '34057', '107', '53696', '16', '3356', '999999999', '665', '28'), ('54', '35595', '112', '55728', '16', '3483', '999999999', '693', '28'), ('55', '37175', '115', '57792', '16', '3612', '999999999', '721', '28'), ('56', '38798', '118', '59888', '16', '3743', '999999999', '749', '30'), ('57', '40465', '121', '62016', '16', '3876', '999999999', '779', '30'), ('58', '42176', '126', '64192', '16', '4012', '999999999', '809', '45'), ('59', '43931', '132', '70550', '17', '4150', '999999999', '854', '45'), ('60', '45731', '137', '72947', '17', '4291', '999999999', '899', '48'), ('61', '47577', '143', '75361', '17', '4433', '999999999', '947', '48'), ('62', '49469', '149', '77826', '17', '4578', '999999999', '995', '48'), ('63', '51408', '156', '80342', '17', '4726', '999999999', '1043', '48'), ('64', '53393', '162', '82875', '17', '4875', '999999999', '1091', '51'), ('65', '55426', '165', '90486', '18', '5027', '999999999', '1142', '51'), ('66', '57508', '169', '93384', '18', '5188', '999999999', '1193', '51'), ('67', '59638', '172', '96318', '18', '5351', '999999999', '1244', '51'), ('68', '61817', '178', '99324', '18', '5518', '999999999', '1295', '54'), ('69', '64045', '185', '102348', '18', '5686', '999999999', '1349', '54'), ('70', '66324', '192', '105444', '18', '5858', '999999999', '1403', '54'), ('71', '68654', '200', '108558', '18', '6031', '999999999', '1457', '54'), ('72', '71034', '207', '117952', '19', '6208', '999999999', '1511', '57'), ('73', '73467', '215', '121353', '19', '6387', '999999999', '1568', '57'), ('74', '75951', '222', '124811', '19', '6569', '999999999', '1625', '57'), ('75', '78488', '230', '128307', '19', '6753', '999999999', '1682', '57'), ('76', '81079', '234', '131860', '19', '6940', '999999999', '1739', '60'), ('77', '83723', '237', '135470', '19', '7130', '999999999', '1799', '60'), ('78', '86422', '241', '139118', '19', '7322', '999999999', '1859', '60'), ('79', '89175', '249', '150340', '20', '7517', '999999999', '1919', '60'), ('80', '91983', '257', '154280', '20', '7714', '999999999', '1979', '63'), ('81', '94847', '266', '158280', '20', '7914', '999999999', '2042', '63'), ('82', '97768', '275', '162340', '20', '8117', '999999999', '2105', '63'), ('83', '100745', '284', '166440', '20', '8322', '999999999', '2168', '63'), ('84', '103779', '293', '170600', '20', '8530', '999999999', '2231', '66'), ('85', '106872', '302', '174820', '20', '8741', '999999999', '2297', '66'), ('86', '110022', '311', '188034', '21', '8954', '999999999', '2363', '66'), ('87', '113232', '321', '192570', '21', '9170', '999999999', '2429', '88'), ('88', '116500', '325', '197148', '21', '9388', '999999999', '2517', '92'), ('89', '119829', '329', '201810', '21', '9610', '999999999', '2609', '92'), ('90', '123218', '333', '206493', '21', '9833', '999999999', '2701', '92'), ('91', '126668', '343', '211260', '21', '10060', '999999999', '2793', '92'), ('92', '130179', '353', '216069', '21', '10289', '999999999', '2885', '96'), ('93', '133752', '363', '231462', '22', '10521', '999999999', '2981', '96'), ('94', '137387', '373', '236808', '22', '10764', '999999999', '3077', '96'), ('95', '141086', '384', '242220', '22', '11010', '999999999', '3173', '96'), ('96', '144848', '395', '247698', '22', '11259', '999999999', '3269', '100'), ('97', '148673', '406', '253220', '22', '11510', '999999999', '3369', '100'), ('98', '152563', '417', '258830', '22', '11765', '999999999', '3469', '100'), ('99', '156518', '429', '264506', '22', '12023', '999999999', '3569', '100'), ('100', '160539', '441', '270248', '22', '12284', '999999999', '3669', '104'), ('101', '164625', '441', '288581', '23', '12547', '999999999', '3773', '104'), ('102', '168778', '449', '294722', '23', '12814', '999999999', '3877', '104'), ('103', '172998', '453', '300932', '23', '13084', '999999999', '3981', '104'), ('104', '177286', '465', '307188', '23', '13356', '999999999', '4085', '108'), ('105', '181641', '477', '313536', '23', '13632', '999999999', '4193', '108'), ('106', '186065', '489', '319953', '23', '13911', '999999999', '4301', '108'), ('107', '190558', '502', '326416', '23', '14192', '999999999', '4409', '108'), ('108', '195120', '515', '332971', '23', '14477', '999999999', '4517', '112'), ('109', '199753', '528', '354336', '24', '14764', '999999999', '4629', '112'), ('110', '204456', '541', '361320', '24', '15055', '999999999', '4741', '112'), ('111', '209230', '554', '368352', '24', '15348', '999999999', '4853', '112'), ('112', '214076', '568', '375456', '24', '15644', '999999999', '4965', '116'), ('113', '218993', '582', '382656', '24', '15944', '999999999', '5081', '116'), ('114', '223984', '596', '389904', '24', '16246', '999999999', '5197', '116'), ('115', '229047', '603', '397248', '24', '16552', '999999999', '5313', '116'), ('116', '234184', '607', '404640', '24', '16860', '999999999', '5429', '150'), ('117', '239395', '609', '429300', '25', '17172', '999999999', '5579', '150'), ('118', '244681', '623', '437400', '25', '17496', '999999999', '5729', '150'), ('119', '250042', '638', '445575', '25', '17823', '999999999', '5879', '150'), ('120', '255479', '652', '453850', '25', '18154', '999999999', '6029', '155'), ('121', '260991', '667', '462200', '25', '18488', '999999999', '6184', '155'), ('122', '266581', '682', '470625', '25', '18825', '999999999', '6339', '155'), ('123', '272248', '698', '479150', '25', '19166', '999999999', '6494', '155'), ('124', '277992', '713', '487750', '25', '19510', '999999999', '6649', '160'), ('125', '283814', '729', '496425', '25', '19857', '999999999', '6809', '160'), ('126', '289716', '745', '525408', '26', '20208', '999999999', '6969', '160'), ('127', '295696', '761', '534612', '26', '20562', '999999999', '7129', '160'), ('128', '301756', '778', '543894', '26', '20919', '999999999', '7289', '165'), ('129', '307896', '795', '553254', '26', '21279', '999999999', '7454', '165'), ('130', '314118', '800', '562718', '26', '21643', '999999999', '7619', '165'), ('131', '320420', '804', '572260', '26', '22010', '999999999', '7784', '165'), ('132', '326804', '808', '581906', '26', '22381', '999999999', '7949', '170'), ('133', '333271', '825', '591630', '26', '22755', '999999999', '8119', '170'), ('134', '339820', '842', '601432', '26', '23132', '999999999', '8289', '170'), ('135', '346452', '859', '634824', '27', '23512', '999999999', '8459', '170'), ('136', '353169', '877', '645192', '27', '23896', '999999999', '8629', '175'), ('137', '359969', '895', '655641', '27', '24283', '999999999', '8804', '175'), ('138', '366855', '913', '666198', '27', '24674', '999999999', '8979', '175'), ('139', '373826', '931', '676836', '27', '25068', '999999999', '9154', '175'), ('140', '380883', '950', '687555', '27', '25465', '999999999', '9329', '180'), ('141', '388026', '969', '698382', '27', '25866', '999999999', '9509', '180'), ('142', '395256', '988', '709290', '27', '26270', '999999999', '9689', '180'), ('143', '402573', '1007', '720306', '27', '26678', '999999999', '9869', '180'), ('144', '409978', '1027', '758464', '28', '27088', '999999999', '10049', '185'), ('145', '417472', '1046', '770364', '28', '27513', '999999999', '10234', '222'), ('146', '425054', '1050', '782376', '28', '27942', '999999999', '10456', '222'), ('147', '432726', '1055', '794500', '28', '28375', '999999999', '10678', '222'), ('148', '440488', '1059', '806708', '28', '28811', '999999999', '10900', '228'), ('149', '448340', '1079', '819000', '28', '29250', '999999999', '11128', '228'), ('150', '456283', '1099', '831432', '28', '29694', '999999999', '11356', '228'), ('151', '464318', '1120', '843948', '28', '30141', '999999999', '11584', '228'), ('152', '472445', '1140', '856548', '28', '30591', '999999999', '11812', '234'), ('153', '480664', '1161', '869288', '28', '31046', '999999999', '12046', '234'), ('154', '488976', '1183', '913616', '29', '31504', '999999999', '12280', '234'), ('155', '497382', '1204', '926985', '29', '31965', '999999999', '12514', '234'), ('156', '505881', '1226', '940499', '29', '32431', '999999999', '12748', '240'), ('157', '514476', '1248', '954100', '29', '32900', '999999999', '12988', '240'), ('158', '523165', '1270', '967817', '29', '33373', '999999999', '13228', '240'), ('159', '531950', '1293', '981621', '29', '33849', '999999999', '13468', '240'), ('160', '540830', '1315', '995541', '29', '34329', '999999999', '13708', '0');
COMMIT;

-- ----------------------------
--  Table structure for `mq_role`
-- ----------------------------
DROP TABLE IF EXISTS `mq_role`;
CREATE TABLE `mq_role` (
  `Id` int(10) NOT NULL,
  `Name` varchar(20) NOT NULL,
  `RoleType` int(2) NOT NULL COMMENT '角色类型',
  `AiType` int(2) NOT NULL,
  `SkillAiType` int(2) NOT NULL,
  `HearRange` float(3,1) NOT NULL COMMENT '听力',
  `VisionRange` float(3,1) NOT NULL COMMENT '视距',
  `IntoRange` float(3,1) NOT NULL COMMENT '进城范围',
  `Level` int(3) NOT NULL,
  `Weapon` int(10) NOT NULL,
  `Shield` int(10) NOT NULL COMMENT '盾牌',
  `Attack` int(6) NOT NULL COMMENT '基础攻击力',
  `Hp` int(8) NOT NULL COMMENT '基础生命',
  `Evade` int(5) NOT NULL COMMENT '闪避这是一个值，需要转化比1W',
  `Armor` int(5) NOT NULL COMMENT '防御护甲',
  `Speed` float(3,1) NOT NULL COMMENT '移动速度',
  `LabelType` int(2) NOT NULL COMMENT '标签类型',
  `Resource` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_role`
-- ----------------------------
BEGIN;
INSERT INTO `mq_role` VALUES ('1', '男主角', '61', '0', '0', '0.0', '7.0', '0.0', '0', '30101', '0', '1', '50', '2000', '20', '1.3', '0', 'man'), ('2', '女主角', '62', '0', '0', '0.0', '7.0', '0.0', '0', '30101', '0', '1', '50', '2000', '20', '1.3', '0', 'man'), ('1001', '小僵尸A', '1', '1', '0', '10.0', '7.0', '0.0', '1', '30101', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1002', '小僵尸B', '1', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1003', '变异豪猪', '1', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1004', '警察僵尸', '1', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '2', 'shangshi'), ('1005', '僵尸胖子', '1', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '3', 'shangshi'), ('1006', '肉弹战车', '1', '4', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '2', 'shangshi'), ('1007', '野狗', '1', '3', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1008', '野牛', '2', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1009', '野马', '2', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1010', '野狗', '2', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1011', '叛军A', '1', '1', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1012', '叛军B', '1', '2', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '2', 'shangshi'), ('1013', '叛军C', '1', '3', '0', '10.0', '7.0', '0.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '3', 'shangshi'), ('1014', '小僵尸A', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1015', '小僵尸B', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1016', '变异豪猪', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', 'shangshi'), ('1017', '警察僵尸', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '2', 'shangshi'), ('1018', '僵尸胖子', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '3', 'shangshi'), ('1019', '肉弹战车', '3', '1', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '2', 'shangshi'), ('1020', '地雷', '21', '0', '0', '10.0', '7.0', '3.0', '1', '1', '0', '1', '50', '2000', '20', '1.3', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `mq_vip`
-- ----------------------------
DROP TABLE IF EXISTS `mq_vip`;
CREATE TABLE `mq_vip` (
  `VipLevel` int(2) NOT NULL COMMENT '等级，从0开始',
  `EnergyRecover` int(3) NOT NULL COMMENT '体力恢复（精力），单次恢复量',
  `EnergyRecoverSat` int(3) NOT NULL COMMENT '饱食状态额外恢复量（精力）',
  `EnergyRecoverOffLine` int(3) NOT NULL COMMENT '离线体力恢复（精力）',
  `VipExp` int(10) NOT NULL COMMENT 'VIP经验',
  `VipFunction` varchar(20) NOT NULL COMMENT 'VIP功能',
  PRIMARY KEY (`VipLevel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_vip`
-- ----------------------------
BEGIN;
INSERT INTO `mq_vip` VALUES ('0', '7', '1', '3', '0', ''), ('1', '8', '1', '4', '1000', ''), ('2', '10', '1', '5', '4500', ''), ('3', '11', '1', '5', '11000', ''), ('4', '12', '1', '6', '21000', ''), ('5', '14', '1', '7', '35500', ''), ('6', '15', '2', '7', '56000', ''), ('7', '16', '2', '8', '84500', ''), ('8', '17', '2', '8', '124500', ''), ('9', '19', '2', '9', '181500', ''), ('10', '20', '2', '10', '264500', ''), ('11', '21', '2', '10', '388500', ''), ('12', '23', '2', '11', '578500', ''), ('13', '24', '2', '12', '877000', ''), ('14', '25', '3', '12', '1357000', ''), ('15', '27', '3', '13', '2146500', ''), ('16', '28', '3', '14', '3471500', ''), ('17', '29', '3', '14', '5735500', ''), ('18', '30', '3', '15', '9667500', ''), ('19', '32', '3', '16', '16599500', ''), ('20', '33', '3', '16', '28989500', '');
COMMIT;

-- ----------------------------
--  Table structure for `mq_weapons`
-- ----------------------------
DROP TABLE IF EXISTS `mq_weapons`;
CREATE TABLE `mq_weapons` (
  `Id` int(10) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `Icon` varchar(10) NOT NULL DEFAULT '' COMMENT '图标',
  `Describe` varchar(64) NOT NULL DEFAULT '' COMMENT '描述',
  `Weight` int(5) NOT NULL DEFAULT '0' COMMENT '重量',
  `Quality` int(11) NOT NULL,
  `Condition` varchar(64) NOT NULL COMMENT '条件',
  `Repeat` int(11) NOT NULL,
  `ItemType` int(2) NOT NULL,
  `EquipType` varchar(32) NOT NULL,
  `AttackRange` float(3,1) NOT NULL DEFAULT '0.0' COMMENT '攻击范围',
  `AttackPer` int(10) NOT NULL DEFAULT '0' COMMENT '攻击力加成，需要比1W',
  `PenetratePer` int(11) NOT NULL DEFAULT '0' COMMENT '穿透力加成，需要比1W',
  `AttackCountMaxPer` int(10) NOT NULL DEFAULT '0' COMMENT '最大伤害数加成，需要比1W',
  `HitPer` int(11) NOT NULL DEFAULT '0' COMMENT '命中率，需要比1W',
  `CriPer` int(11) NOT NULL DEFAULT '0' COMMENT '暴击率，需要比1W',
  `CriDamagePlus` int(11) NOT NULL DEFAULT '0' COMMENT '暴击伤害加成，需要比1W',
  `CriSeniorPer` int(11) NOT NULL DEFAULT '0' COMMENT '高级暴击率，需要比1W',
  `CriSeniorDamagePlus` int(10) NOT NULL DEFAULT '0' COMMENT '高级暴击伤害加成，需要比1W',
  `AimTime` int(11) NOT NULL DEFAULT '0' COMMENT '瞄准时间',
  `ReloadTime` int(11) NOT NULL DEFAULT '0' COMMENT '装弹时间',
  `Endurance` int(5) NOT NULL DEFAULT '0' COMMENT '耐久',
  `Sell` int(5) NOT NULL DEFAULT '0' COMMENT '售价',
  `ShootNum` int(11) NOT NULL DEFAULT '0' COMMENT '射数',
  `Capacity` int(11) NOT NULL DEFAULT '0' COMMENT '弹药量',
  `VisionRange` float(11,0) NOT NULL DEFAULT '0' COMMENT '视距',
  `BallGroup` varchar(20) NOT NULL DEFAULT '' COMMENT '子弹组',
  `ClipGroup` varchar(20) NOT NULL DEFAULT '' COMMENT '弹夹组',
  `BulletShellEffects` varchar(20) NOT NULL DEFAULT '' COMMENT '弹壳特效',
  `Resource` varchar(64) NOT NULL DEFAULT '',
  `SkillId` int(6) NOT NULL DEFAULT '0' COMMENT '技能ID，需要比1W',
  `Function` varchar(10) NOT NULL DEFAULT '' COMMENT '附属功能',
  `Angle` int(3) NOT NULL DEFAULT '0' COMMENT '扇形角度',
  `Attack` int(6) NOT NULL DEFAULT '0' COMMENT '基础攻击力，枪械子弹还有加成',
  `Effects` varchar(10) NOT NULL DEFAULT '' COMMENT '特效',
  `AttackCount` int(2) NOT NULL DEFAULT '0' COMMENT '最大攻击人数',
  `Block` int(5) NOT NULL DEFAULT '0' COMMENT '盾牌格挡值',
  `JoinPointId` varchar(32) NOT NULL DEFAULT '‘’',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `mq_weapons`
-- ----------------------------
BEGIN;
INSERT INTO `mq_weapons` VALUES ('30101', '第1套单手近战01', 'w30001', '第1套单手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30102', '第1套单手近战02', 'w30002', '第1套单手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30103', '第1套单手近战03', 'w30003', '第1套单手近战03', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30104', '第1套双手近战01', 'w30004', '第1套双手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30105', '第1套双手近战02', 'w30005', '第1套双手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30106', '第1套单手盾牌01', 'w30006', '第1套单手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '5003'), ('30107', '第1套双手盾牌01', 'w30007', '第1套双手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '5004'), ('30108', '第1套手枪01', 'w30008', '第1套手枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '5001'), ('30109', '第1套手枪02', 'w30009', '第1套手枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30110', '第1套机枪01', 'w30010', '第1套机枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30111', '第1套机枪02', 'w30011', '第1套机枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30112', '第1套散弹枪01', 'w30012', '第1套散弹枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30113', '第1套狙击枪01', 'w30013', '第1套狙击枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '5002'), ('30114', '第1套加特林01', 'w30014', '第1套加特林01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30201', '第2套单手近战01', 'w30001', '第2套单手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30202', '第2套单手近战02', 'w30002', '第2套单手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30203', '第2套单手近战03', 'w30003', '第2套单手近战03', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30204', '第2套双手近战01', 'w30004', '第2套双手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30205', '第2套双手近战02', 'w30005', '第2套双手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30206', '第2套单手盾牌01', 'w30006', '第2套单手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30207', '第2套双手盾牌01', 'w30007', '第2套双手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30208', '第2套手枪01', 'w30008', '第2套手枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30209', '第2套手枪02', 'w30009', '第2套手枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30210', '第2套机枪01', 'w30010', '第2套机枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30211', '第2套机枪02', 'w30011', '第2套机枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30212', '第2套散弹枪01', 'w30012', '第2套散弹枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30213', '第2套狙击枪01', 'w30013', '第2套狙击枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30214', '第2套加特林01', 'w30014', '第2套加特林01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30301', '第3套单手近战01', 'w30001', '第3套单手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30302', '第3套单手近战02', 'w30002', '第3套单手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30303', '第3套单手近战03', 'w30003', '第3套单手近战03', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30304', '第3套双手近战01', 'w30004', '第3套双手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30305', '第3套双手近战02', 'w30005', '第3套双手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30306', '第3套单手盾牌01', 'w30006', '第3套单手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30307', '第3套双手盾牌01', 'w30007', '第3套双手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30308', '第3套手枪01', 'w30008', '第3套手枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30309', '第3套手枪02', 'w30009', '第3套手枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30310', '第3套机枪01', 'w30010', '第3套机枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30311', '第3套机枪02', 'w30011', '第3套机枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30312', '第3套散弹枪01', 'w30012', '第3套散弹枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30313', '第3套狙击枪01', 'w30013', '第3套狙击枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30314', '第3套加特林01', 'w30014', '第3套加特林01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30401', '第4套单手近战01', 'w30001', '第4套单手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30402', '第4套单手近战02', 'w30002', '第4套单手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30403', '第4套单手近战03', 'w30003', '第4套单手近战03', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30404', '第4套双手近战01', 'w30004', '第4套双手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30405', '第4套双手近战02', 'w30005', '第4套双手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30406', '第4套单手盾牌01', 'w30006', '第4套单手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30407', '第4套双手盾牌01', 'w30007', '第4套双手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30408', '第4套手枪01', 'w30008', '第4套手枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30409', '第4套手枪02', 'w30009', '第4套手枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30410', '第4套机枪01', 'w30010', '第4套机枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30411', '第4套机枪02', 'w30011', '第4套机枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30412', '第4套散弹枪01', 'w30012', '第4套散弹枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30413', '第4套狙击枪01', 'w30013', '第4套狙击枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30414', '第4套加特林01', 'w30014', '第4套加特林01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30501', '第5套单手近战01', 'w30001', '第5套单手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30502', '第5套单手近战02', 'w30002', '第5套单手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30503', '第5套单手近战03', 'w30003', '第5套单手近战03', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30504', '第5套双手近战01', 'w30004', '第5套双手近战01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30505', '第5套双手近战02', 'w30005', '第5套双手近战02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30506', '第5套单手盾牌01', 'w30006', '第5套单手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30507', '第5套双手盾牌01', 'w30007', '第5套双手盾牌01', '20', '1', '0', '1', '25000', '9', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30508', '第5套手枪01', 'w30008', '第5套手枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30509', '第5套手枪02', 'w30009', '第5套手枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30510', '第5套机枪01', 'w30010', '第5套机枪01', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0'), ('30511', '第5套机枪02', 'w30011', '第5套机枪02', '20', '1', '0', '1', '25000', '8', '2.0', '1000', '0', '0', '8000', '1000', '1000', '1000', '1000', '1000', '1500', '100', '100', '1', '20', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Score` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2147483651 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `test`
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES ('1', 'oneal', '95'), ('2', 'kobe', '90'), ('3', 'haha', '92'), ('7', 'dfds', '88'), ('2147483648', 'bfbfd', '99'), ('2147483649', 'kaka', '88'), ('2147483650', 'maka', '92');
COMMIT;

-- ----------------------------
--  Procedure structure for `proc_create_character`
-- ----------------------------
DROP PROCEDURE IF EXISTS `proc_create_character`;
delimiter ;;
CREATE DEFINER=`liveadmin`@`%` PROCEDURE `proc_create_character`(in p_userid int)
BEGIN
	insert into d_character(UserId,RoleId,Level,Exp,ItemUidSeed,CurrentHp,MaxHp,EvadePer,Gold) 
    values(p_userid, 1, 1, 0, 1, 100, 100, 0, 1000);
    
    insert into d_bodyequipment(CharId)
    values(@@identity);
END
 ;;
delimiter ;

-- ----------------------------
--  Procedure structure for `proc_read_bag`
-- ----------------------------
DROP PROCEDURE IF EXISTS `proc_read_bag`;
delimiter ;;
CREATE DEFINER=`liveadmin`@`%` PROCEDURE `proc_read_bag`(in p_charid int)
BEGIN
	select * from d_bagitems where CharId=p_charid;
    
    select * from d_bagequipment where CharId=p_charid;
    
    select * from d_bagweapon where CharId=p_charid;
END
 ;;
delimiter ;

-- ----------------------------
--  Procedure structure for `proc_read_character`
-- ----------------------------
DROP PROCEDURE IF EXISTS `proc_read_character`;
delimiter ;;
CREATE DEFINER=`liveadmin`@`%` PROCEDURE `proc_read_character`(in p_charid int, out p_userid int)
BEGIN
	declare v_user_id int;
	select UserId into v_user_id from d_character where Id=p_charid; 
    set p_userid=v_user_id;
    
	select * from d_character where Id=p_charid; 
    
    select * from d_bodyequipment where CharId=p_charid;
    
	select * from d_bagitems where CharId=p_charid;
    
    select * from d_bagequipment where CharId=p_charid;
    
    select * from d_bagweapon where CharId=p_charid;
  
END
 ;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
